SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 44147: Using the XLS driver to import .xls files on UNIX platforms might cause SAS® to stop responding

DetailsAboutRate It

SAS might stop functioning if you try to import Microsoft Excel (.xls) files using the XLS driver on UNIX platforms. The same file imports correctly on a Windows platform. The problem occurs under the following circumstances:

  • When you use both the GETNAMES=NO option and the RANGE= option
  • When the range imported contains no values in the cells

To circumvent the problem, do one of the following:

  • Contact SAS Technical Support to request a hot fix
  • Add one dummy value to the range of data in the Excel worksheet and delete it in SAS
  • Alter the range to include data or remove the RANGE= value entirely


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to PC FilesLinux9.21_M29.21_M29.2 TS2M39.3 TS1M1
HP-UX IPF9.21_M29.21_M29.2 TS2M39.3 TS1M1
64-bit Enabled Solaris9.21_M29.21_M29.2 TS2M39.3 TS1M1
64-bit Enabled HP-UX9.21_M29.21_M29.2 TS2M39.3 TS1M1
64-bit Enabled AIX9.21_M29.21_M29.2 TS2M39.3 TS1M1
Linux for x649.21_M29.21_M29.2 TS2M39.3 TS1M1
Solaris for x649.21_M29.21_M29.2 TS2M39.3 TS1M1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.